Online Analytical Processing Systems
نویسنده
چکیده
Since its origin in the 1970’s research and development into databases systems has evolved from simple file storage and processing systems to complex relational databases systems, which have provided a remarkable contribution to the current trends or environments. Databases are now such an integral part of day-to-day life that often people are unaware of their use. For example, purchasing goods from the local supermarket is likely to involve access to a database. In order to retrieve the price of the item, the application program will access the product database. A database is a collection of related data and the database management system (DBMS) is software that manages and controls access to the database (Elmasri & Navathe, 2004).
منابع مشابه
Online Data Mining
INTRODUCTION Currently, most data warehouses are being used for summarizationbased, multi-dimensional, online analytical processing (OLAP). However, given the recent developments in data warehouse and online analytical processing technology, together with the rapid progress in data mining research, industry analysts anticipate that organizations will soon be using their data warehouses for soph...
متن کاملOn-Line Analytical Processing with Conceptual Information Systems
A Conceptual Information System consists of a database together with conceptual hierarchies. The management system TOSCANA visualizes arbitrary combinations of conceptual hierarchies by nested line diagrams and allows an on-line interaction with a database to analyze data conceptually. The paper describes the conception of Conceptual Information Systems and discusses the use of their visualizat...
متن کاملNext Generation Data Warehouse Design with OLTP and OLAP Systems Sharing same Database
Online Transaction Processing (OLTP) systems have been using the traditional relational Database management system for many years. Online Analytical Processing (OLAP) system for analytical reporting is optimized to aggregate many records which involve more read operations. Hence to enhance the performance in OLAP systems various modeling options like star schema, extended star schema was implem...
متن کاملData Warehousing Applications: an Analytical Tool for Decision Support System
Data-driven decision support systems, such as data warehouses can serve the requirement of extraction of information from more than one subject area. Data warehouses standardize the data across the organization so as to have a single view of information. Data warehouses (DW) can provide the information required by the decision makers. The data warehouse supports an on-line analytical processing...
متن کاملChapter 14 CONCEPTUAL ON - LINE ANALYTICAL PROCESSING
A Conceptual Information System consists of a database together with conceptual hierarchies. The visualization of arbitrary combinations of conceptual hierarchies by nested line diagrams allows an on-line interaction with a database to analyze data conceptually. The chapter describes the conception of Conceptual Information Systems and discusses the use of their visualization techniques for On-...
متن کاملOnline Analytical Processing (OLAP) for Decision Support
Nenad Jukic 1 , Boris Jukic 2 , and Mary Malliaris 1 School of Business Administration, Loyola University Chicago, Chicago, IL, USA School of Business, Clarkson University, Potsdam, NY, USA _____________________________________________________________________________________ Online Analytical Processing (OLAP) refers to the general activity of querying and presenting text and number data from d...
متن کامل